Modify multiple nodes in a document in a single UPDATE statement 在一个UPDATE语句中修改文档中的多个节点
The application submits an SQL UPDATE statement and transmits the updated document to the database server. 应用程序提交一个SQLUPDATE语句,把更新后的文档传输给数据库服务器。
The naive approach uses a cursor to scan the table and execute a positioned update statement for each row. 初级的方法是使用一个游标对表进行扫描,并为每一行执行一个定位的更新语句。
However, the rename only applies to phone elements in the original document, and not to the new phone element that is added in the same update statement. 但是,重命名操作只应用于原文档中的“phone”元素,对于在同一个更新语句中添加的“phone”元素不起作用。
The UPDATE statement modifies both the price and the stockDate columns for this specific row. UPDATE语句修改该特定行的price和stockDate列。
Full document update using the SQL update statement. 使用SQLupdate语句进行全文档更新。
You can add or change a namespace by using UPDATE statement, but you need to map all elements. 可以通过使用UPDATE语句添加或更改名称空间。
The set clause of the UPDATE statement replaces the existing document in a given row with a new document. UPDATE语句的set子句用一个新文档替换给定行中的现有文档。
The UPDATE statement results in an exclusive ( X) lock on each row in the EMPLOYEE table. UPDATE语句会导致EMPLOYEE表中的每行上发生一个独占(X)锁。
Update multiple documents in a single UPDATE statement 在一个UPDATE语句中更新多个文档
At some level, the SQL UPDATE statement is the union of the SQL INSERT and DELETE statements, because you must select rows to modify as well as specify how to modify them. 在某种程度上,SQLUPDATE语句是SQLINSERT和DELETE语句的联合,因为您必须选择要修改的行,还必须指定如何修改它们。
The UPDATE statement fails if the modified document is not valid. 如果更新后的文档是无效的,UPDATE语句就会失败。
If you move the position update statement to a different package it is necessary to perform a configure. 如果将位置更新语句移动到不同的包,则需要进行相应的配置。
Most of the examples in this article show the transform expression in an SQL UPDATE statement. 本文中的大多数示例在SQLUPDATE语句中使用转换表达式。
This example wraps a single UPDATE statement with SELECT statements to demonstrate the change to the target row. 本示例在UPDATE语句的前后都使用了SELECT语句,以证实对目标行的更改。
To ensure that all existing rows are handled properly, the UPDATE statement is run. 为了确保所有已有的行都得到适当的处理,运行UPDATE语句。
In this scenario, it is the UPDATE statement to increase the salary of each employee. 在这个场景中,使用UPDATE语句增加每个员工的工资。
The null indicator values are set by the RPG HANDLE_UPDATE sub-procedure prior to executing the SQL UPDATE statement. 空指示符值在执行SQLUPDATE语句之前通过RPGHANDLEUPDATE子过程设置。
The structure of the combined plan is nearly identical to that of the UPDATE statement alone. 这个组合的计划在结构上与单独的UPDATE语句几乎一样。
Next you used the SQL UPDATE statement to modify the column values for selected rows in a table. 然后使用SQLUPDATE语句来修改表中选定行的列值。
This is followed by an update statement to actually insert XML data. 然后是一个更新语句,它实际插入XML数据。
Often you will want to prepare and compile the UPDATE statement only once, and then pass in a new value every time you execute the update. 常常希望只准备和编译UPDATE语句一次,然后在每次执行更新时传递一个新值。
Figure 10 shows that an update statement is manipulating a column that contains private data. 图10显示一个更新语句正在操作一个包含私有数据的列。
You can certainly make multiple modifications to the same document in a single update statement. 可以在单一更新语句中对同一文档做多处修改。
Test things out by issuing an update statement. 可以通过一个update语句来进行测试。
Table aliases are not accepted in the set clause of an update statement. 在update语句的set子句中,不接受表的别名。
The columns listed in the update statement are based on the field data members that have changed. update语句中列出的列基于已发生更改的字段数据成员。
In the following example, the update statement will cause a recompile of the module. 在下面的示例中,update语句将导致模块的重新编译。
Variable names can be used in update statements to show the old and new values affected, but this should be used only when the update statement affects a single record. 可以在update语句中使用变量名称来显示受影响的旧值和新值,但仅当update语句影响单个记录时才应使用变量名称。